BEGIN TRANSACTION
GO
ALTER TABLE dbo.Appconfig ADD
	DefaultBilityRecForm tinyint NOT NULL CONSTRAINT DF_Appconfig_DefaultBilityRecForm DEFAULT 0
GO
COMMIT

------------------------------------------------------------------------------------------------------

BEGIN TRANSACTION
GO
ALTER TABLE dbo.Voucher ADD
	Paid tinyint NOT NULL CONSTRAINT DF_Voucher_Paid DEFAULT 0
GO
COMMIT

------------------------------------------------------------------------------------------------------

USE [BS5]
GO
/****** Object:  View [dbo].[VW_Vouchers]    Script Date: 12/15/2016 12:59:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[VW_Vouchers]
AS
SELECT     dbo.Voucher.VoucherID, dbo.Voucher.VoucherDate, dbo.Voucher.VoucherNo, dbo.Voucher.SessionID, dbo.SessionInfo.SessionTitle, dbo.SessionInfo.SessionFrom, 
                      dbo.SessionInfo.SessionTo, dbo.SessionInfo.CurrentSession, dbo.Voucher.Remarks AS MasterRemarks, dbo.Voucher.ReadOnly, dbo.VoucherDetails.VoucherDetailID, 
                      dbo.VoucherDetails.AccountNo, dbo.Accounts.AccountTitle, dbo.VoucherDetails.Remarks, dbo.Voucher.SenderID, Accounts_1.AccountTitle AS SenderName, 
                      dbo.Voucher.ReceiverID, Accounts_2.AccountTitle AS ReceiverName, dbo.Voucher.LoginID, dbo.Voucher.EntryDateTime, dbo.Voucher.HostName, 
                      dbo.Voucher.StationFromID, dbo.Station.StationName AS StationFromName, dbo.Station.StationNameUrdu AS StationFromNameUrdu, dbo.Voucher.StationToID, 
                      Station_1.StationNameUrdu AS StationToNameUrdu, Station_1.StationName AS StationToName, dbo.Voucher.VehicleID, Accounts_3.AccountTitle AS VehicleName, 
                      dbo.Voucher.BillityNo, CASE WHEN (dbo.VoucherDetails.DrOrCr = N'Dr') THEN dbo.VoucherDetails.Amount ELSE - 1 * dbo.VoucherDetails.Amount END AS Amount, 
                      CASE WHEN (dbo.VoucherDetails.DrOrCr = N'Dr') THEN dbo.VoucherDetails.Amount ELSE 0 END AS Debit, CASE WHEN (dbo.VoucherDetails.DrOrCr = N'Cr') 
                      THEN dbo.VoucherDetails.Amount ELSE 0 END AS Credit, dbo.VoucherDetails.DrOrCr, dbo.Accounts.ParentAccount, dbo.VoucherDetails.Amount AS ActualAmount, 
                      dbo.vw_Items.GroupID, dbo.vw_Items.GroupName, dbo.VoucherDetails.ItemID, dbo.vw_Items.ItemCode, dbo.vw_Items.ItemName, dbo.vw_Items.ItemNameUrdu, 
                      dbo.VoucherDetails.Notes, dbo.VoucherDetails.Qty, dbo.VoucherDetails.Rate, dbo.VoucherDetails.Weight, dbo.Voucher.TotalAmount, dbo.Voucher.Loading, 
                      dbo.Voucher.GodownIn, dbo.Voucher.MiscIn, dbo.Voucher.GrossAmount, dbo.Voucher.UnLoading, dbo.Voucher.GodownOut, dbo.Voucher.MiscOut, 
                      dbo.Voucher.NetAmount, dbo.Voucher.Expense, dbo.Voucher.Discount, dbo.Voucher.CustomerName, dbo.VoucherDetails.DBillityNo, dbo.VoucherDetails.DSenderID, 
                      Accounts_4.AccountTitle AS DSenderName, dbo.VoucherDetails.DReceiverID, Accounts_5.AccountTitle AS DReceiverName, dbo.VoucherDetails.DGrossAmount, 
                      dbo.Voucher.Paid
FROM         dbo.Accounts AS Accounts_1 RIGHT OUTER JOIN
                      dbo.Accounts AS Accounts_3 RIGHT OUTER JOIN
                      dbo.Accounts RIGHT OUTER JOIN
                      dbo.vw_Items RIGHT OUTER JOIN
                      dbo.VoucherDetails RIGHT OUTER JOIN
                      dbo.Voucher ON dbo.VoucherDetails.VoucherID = dbo.Voucher.VoucherID LEFT OUTER JOIN
                      dbo.Accounts AS Accounts_5 ON dbo.VoucherDetails.DReceiverID = Accounts_5.AccountNo LEFT OUTER JOIN
                      dbo.Accounts AS Accounts_4 ON dbo.VoucherDetails.DSenderID = Accounts_4.AccountNo ON dbo.vw_Items.ItemID = dbo.VoucherDetails.ItemID ON 
                      dbo.Accounts.AccountNo = dbo.VoucherDetails.AccountNo ON Accounts_3.AccountNo = dbo.Voucher.VehicleID LEFT OUTER JOIN
                      dbo.Station AS Station_1 ON dbo.Voucher.StationToID = Station_1.StationID LEFT OUTER JOIN
                      dbo.Accounts AS Accounts_2 ON dbo.Voucher.ReceiverID = Accounts_2.AccountNo ON Accounts_1.AccountNo = dbo.Voucher.SenderID LEFT OUTER JOIN
                      dbo.SessionInfo ON dbo.Voucher.SessionID = dbo.SessionInfo.SessionID LEFT OUTER JOIN
                      dbo.Station ON dbo.Voucher.StationFromID = dbo.Station.StationID

------------------------------------------------------------------------------------------------------